<?php
require "include/bittorrent.php";
dbconn();
require_once(get_langfile_path());
loggedinorreturn();
if (get_user_class() < $forummanage_class)
	permissiondenied();

//Presets
$act = $_GET['action'];
$id = 0 + $_GET['id'];

if (!$act) {
	$act = "forum";
}

// DELETE FORUM ACTION
if ($act == "del") {
	if (get_user_class() < $forummanage_class)
		permissiondenied();

	if (!$id) {
		header("Location: $PHP_SELF?action=forum");
		die();
	}

	sql_query("DELETE FROM overforums WHERE id = " . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
	$Cache->delete_value('overforums_list');
	header("Location: $PHP_SELF?action=forum");
	die();
}

//EDIT FORUM ACTION
if ($_POST['action'] == "editforum") {
	if (get_user_class() < $forummanage_class)
		permissiondenied();

	$name = $_POST['name'];
	$desc = $_POST['desc'];

	if (!$name && !$desc && !$id) {
		header("Location: $PHP_SELF?action=forum");
		die();
	}

	sql_query("UPDATE overforums SET sort = " . sqlesc($_POST['sort']) . ", name = " . sqlesc($_POST['name']) . ", description = " . sqlesc($_POST['desc']) . ", minclassview = " . sqlesc($_POST['viewclass']) . " WHERE id = " . sqlesc($_POST['id'])) or sqlerr(__FILE__, __LINE__);
	$Cache->delete_value('overforums_list');
	header("Location: $PHP_SELF?action=forum");
	die();
}

//ADD FORUM ACTION
if ($_POST['action'] == "addforum") {
	if (get_user_class() < $forummanage_class)
		permissiondenied();

	$name = trim($_POST['name']);
	$desc = trim($_POST['desc']);

	if (!$name && !$desc) {
		header("Location: $PHP_SELF?action=forum");
		die();
	}

	sql_query("INSERT INTO overforums (sort, name, description, minclassview) VALUES(" . sqlesc($_POST['sort']) . ", " . sqlesc($_POST['name']) . ", " . sqlesc($_POST['desc']) . ", " . sqlesc($_POST['viewclass']) . ")") or sqlerr(__FILE__, __LINE__);
	$Cache->delete_value('overforums_list');

	header("Location: $PHP_SELF?action=forum");
	die();
}

stdhead($lang_moforums['head_overforum_management']);
begin_main_frame();

if ($act == "forum") {

// SHOW FORUMS WITH FORUM MANAGMENT TOOLS
	?>
	<h2 align=center><a class=faqlink href=forummanage.php><?php echo $lang_moforums['text_forum_management'] ?></a><b>--></b><?php echo $lang_moforums['text_overforum_management'] ?></h2>
	<br />
	<?php
	echo '<table width="100%"  border="0" align="center" cellpadding="2" cellspacing="0">';
	echo "<tr><td class=colhead align=left>" . $lang_moforums['col_name'] . "</td><td class=colhead>" . $lang_moforums['col_viewed_by'] . "</td><td class=colhead>排序</td><td class=colhead>" . $lang_moforums['col_modify'] . "</td></tr>";
	$result = sql_query("SELECT  * FROM overforums ORDER BY sort ASC");
	if (mysql_num_rows($result) > 0) {
		while ($row = mysql_fetch_array($result)) {


			echo "<tr><td><a href=forums.php?action=forumview&forid=" . $row["id"] . "><b>" . htmlspecialchars($row["name"]) . "</b></a><br />" . $row["description"] . "</td>";
			echo "<td>" . get_user_class_name_zh($row["minclassview"], false, true, true) . "</td><td>" . $row['sort'] . "</td><td><b><a href=\"" . $PHP_SELF . "?action=editforum&id=" . $row["id"] . "\">" . $lang_moforums['text_edit'] . "</a>&nbsp;|&nbsp;<a href=\"javascript:confirm_delete('" . $row["id"] . "', '" . $lang_moforums['js_sure_to_delete_overforum'] . "', '');\"><font color=red>" . $lang_moforums['text_delete'] . "</font></a></b></td></tr>";
		}
	} else {
		print "<tr><td colspan=3>" . $lang_moforums['text_no_records_found'] . "</td></tr>";
	}
	echo "</table>";
	?>
	<br /><br />
	<form method=post action="<?php echo $PHP_SELF; ?>">
		<table width="100%"  border="0" cellspacing="0" cellpadding="3" align="center">
			<tr align="center">
				<td colspan="2" class=colhead><?php echo $lang_moforums['text_new_overforum'] ?></td>
			</tr>
			<tr>
				<td><b><?php echo $lang_moforums['text_overforum_name'] ?></td>
				<td><input name="name" type="text" style="width: 200px" maxlength="60"></td>
			</tr>
			<tr>
				<td><b><?php echo $lang_moforums['text_overforum_description'] ?></td>
				<td><input name="desc" type="text" style="width: 400px" maxlength="200"></td>
			</tr>

			<tr>
				<td><b><?php echo $lang_moforums['text_minimum_view_permission'] ?></td>
				<td>
					<select name=viewclass>\n
						<?php
						$maxclass = get_user_class();
						for ($i = 0; $i <= $maxclass; ++$i)
							print("<option value=$i" . ($user["class"] == $i ? " selected" : "") . ">$prefix" . get_user_class_name_zh($i, false, true, true) . "\n");
						?>
					</select>
				</td>
			</tr>

			<tr>
				<td><b><?php echo $lang_moforums['text_overforum_order'] ?></td>
				<td>
					<select name=sort>
						<?php
						$res = sql_query("SELECT sort FROM overforums");
						$nr = mysql_num_rows($res);
						$maxclass = $nr + 1;
						for ($i = 0; $i <= $maxclass; ++$i)
							print("<option value=$i>$i \n");
						?>
					</select>
					<?php echo $lang_forummanage['text_overforum_order_note'] ?></td>
			</tr>

			<tr align="center">
				<td colspan="2"><input type="hidden" name="action" value="addforum"><input type="submit" name="Submit" value="<?php echo $lang_moforums['submit_make_overforum'] ?>"></td>
			</tr>
		</table>

		<?php
	}
	?>

	<?php
	if ($act == "editforum") {

//EDIT PAGE FOR THE FORUMS
		$id = 0 + $_GET["id"];

		$result = sql_query("SELECT * FROM overforums where id = '$id'");
		if (mysql_num_rows($result) > 0) {

// Get OverForum Name - To Be Written

			while ($row = mysql_fetch_array($result)) {
				?>
				<h2 align=center><a class=faqlink href=forummanage.php><?php echo $lang_moforums['text_forum_management'] ?></a><b>--></b><a class=faqlink href=moforums.php><?php echo $lang_moforums['text_overforum_management'] ?></a><b>--></b><?php echo $lang_moforums['text_edit_overforum'] ?></h2><br />
				<form method=post action="<?php echo $PHP_SELF; ?>">
					<table width="100%"  border="0" cellspacing="0" cellpadding="3" align="center">
						<tr align="center">
							<td colspan="2" class=colhead><?php echo $lang_moforums['text_edit_overforum'] ?> -- <?php echo htmlspecialchars($row["name"]); ?></td>
						</tr>

						<td><b><?php echo $lang_moforums['text_overforum_name'] ?></td>
						<td><input name="name" type="text" style="width: 200px" maxlength="60" value="<?php echo $row["name"]; ?>"></td>
						</tr>
						<tr>
							<td><b><?php echo $lang_moforums['text_overforum_description'] ?></td>
							<td><input name="desc" type="text" style="width: 400px" maxlength="200" value="<?php echo $row["description"]; ?>"></td>
						</tr>


						<tr>
							<td><b><?php echo $lang_moforums['text_minimum_view_permission'] ?></td>
							<td>
								<select name=viewclass>
									<?php
									$maxclass = get_user_class();
									for ($i = 0; $i <= $maxclass; ++$i)
										print("<option value=$i" . ($row["minclassview"] == $i ? " selected" : "") . ">$prefix" . get_user_class_name_zh($i, false, true, true) . "\n");
									?>
								</select>
							</td>
						</tr>


						<tr>
							<td><b><?php echo $lang_moforums['text_overforum_order'] ?></td>
							<td>
								<select name=sort>
									<?php
									$res = sql_query("SELECT sort FROM overforums");
									$nr = mysql_num_rows($res);
									$maxclass = $nr + 1;
									for ($i = 0; $i <= $maxclass; ++$i)
										print("<option value=$i" . ($row["sort"] == $i ? " selected" : "") . ">$i \n");
									?>
								</select>
								<?php echo $lang_moforums['text_overforum_order_note'] ?>
							</td>
						</tr>

						<tr align="center">
							<td colspan="2"><input type="hidden" name="action" value="editforum"><input type="hidden" name="id" value="<?php echo $id; ?>"><input type="submit" name="Submit" value="<?php echo $lang_moforums['submit_edit_overforum'] ?>"></td>
						</tr>
					</table>

					<?php
				}
			} else {
				print $lang_moforums['text_no_records_found'];
			}
		}
		end_main_frame();
		stdfoot();
